2016-11-17 - 28398 - Spec - Update Production Order Pay Stickers #ProductionOrders #ABAPSUPPORT

SPECIFICATIONS

28398-Spec-Update Production Order Pay Stickers


Purpose


Update Production Order Pay Stickers

Admin Info


Purpose
Update Production Order Pay Stickers
Requested By
Matt
Spec Created By
Adithya,Laxman
Spec Created Date
11/17/2016
Spec QA by
Adithya
Objects
ZOP_SEQ_LOOKUP
ZPP_PROD_ORDER_PRINT
Document Status
Complete

Estimates



Sl.No
Activity
Estimation in Hours
1
Research

2
Documentation
04
3
Development/ Config
12
4
Unit test in DEV
08
5
Unit test in QUA

6
Other activity


TOTAL
24

References


Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

M01_OperationNumbers.txt

PROD sheet - original revised 10 13 16.pdf

Spec Changes


[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
Change Details
Requested By
Requested On
Notes if any





Functional Requirement


Change the logic used in the CO02 and COHV transactions that produce the pay stickers that are printed on the production order forms.
The stickers need to show the correct op sequence when there is an op sequence with mixed sizes.
We will add a Z table in SAP containing the correct values that will be used as a look up table to return the correct value on the sticker.

Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
All operation sequences that have mixed rates do not show correctly on the sticker.

In Scope:

[List the activities to be included in scope]
All the Production Order forms.

Out of Scope:

[Out of scope activities]

Solution Summary


[Discuss this section with Requester and get approval prior to beginning work]
Below is the production Order form for Order 1000746015. These stickers (With Bar code) are pasted on another sheet which is shown in attached document "PROD sheet - original revised 10 13 16"

28398-1.JPG

Create a Custom Z table "ZOP_SEQ_LOOKUP" in which the users can maintain the values.
Assign a T code to table so that it can be accessed and values can be maintained.

Change the Production Order Form so as to replace the Standard Text Key by the values maintained in Custom Z table "ZOP_SEQ_LOOKUP".

Consider the first 3 digits of the standard value key, If
- Count Value in the bar code (Number of Sizes) is equal to 1 then Pull 2nd Column value maintained in the below table.
- Count Value in the bar code (Number of Sizes) is Greater than 1 then Pull 3rd Column value maintained in the below table.

Values maintained in the table for this are
Attached is the document containing the data to be filled in the table:

M01_OperationNumbers.txt

Std Text Key
If Count is Equal to 1
If Count is greater than 1
60
60
60
320
320
321

For Example considering the Below Sticker.
28398-2.JPG
From above example standard text key value is 0600, and Count (Number of Sizes) is Equal to 1. Then the value maintained corresponding to 60 in 2nd Column shall be replaced with the standard text key in the Production Order form.
Making it as
TAPE FB 1000746015 0600 0000060 1

Here is another example which is a cap machine Production Order:
28398-4.JPG
Standard Text Key is 3200, Considering first 3 digits it is 320 and the Count (Number of Sizes) is greater than 1, Then the value maintained corresponding to 320 in the 3rd Column shall be considered and replaced in the Production Order form.
Making it as
BL BLOCKING 1000806788 3210 0000004 3

While Testing in NEQ 600 on 01/13/2017.
While maintaining values in table "ZOP_SEQ_LOOKUP" understand that a transport request is generated while saving it.
NEQ 100 is open and it allowed to maintain the values in the table. Whereas NEQ 600 is not open and transport request is generated while maintaining data in the table.

Transport pop up generated as recording routine checkbox is unchecked while creating table maintenance generator. We made changes so as when we do a table maintenance it won't ask for a transport when the system is not open.

Test Plan

[List test scenarios/cases to be executed here]
Test ID
Test Scenario
Expected Results
POF1
Create a Production Order with One size and Print the Production order form
Standard Text Key in the Production Order form shall be replaced with the lookup values maintained in the Z Table.
With Logic Equal 1.
POF2
Create a Production Order with multiple sizes and Print the Production order form
Standard Text Key in the Production Order form shall be replaced with the lookup values maintained in the Z Table.
With Logic greater than 1.
POF3
Create a Production Order with multiple sizes and Print the Production Order form through COHV
Standard Text Key in the Production Order form shall be replaced with the lookup values maintained in the Z Table. With Logic greater than 1.
Solution Details

[Provide complete technical details for configuration or programming here]
Create a table to maintain the Values by users - ZOP_SEQ_LOOKUP and Create a transaction to access the table.
Change the Production Order Print Program "ZPP_PROD_ORDER_PRINT" so as the Standard Text Key shall be replaced with the value maintained in the Z Table "ZOP_SEQ_LOOKUP" and displayed on the Production Order Form.

01/13/2017: For Transport Request issue flag the checkbox for table maintenance generator.

Issues

[List Issues / Bugs identified in configuration or development]

2016-11-21 - 28398 - Release Notes - Update Production Order Pay Stickers